# handle surface dF data

using Plots;gr()
using XLSX
using DataFrames

print("Please input the filename:")
filename = readline(stdin)
print("Please input the sheetname:")
shname = readline(stdin)

ine = 50 # elements number of the blade 
dfor = DataFrame(XLSX.readtable(filename, shname)...)
sumlen = length(dfor[:,3])
ilen = floor(Int,sumlen/ine)

fz = zeros(ine+1)
for i in 1:ine
    fz[i] = sum(dfor[1+ilen*(i-1):ilen*i, 3])
end 
fz[ine+1] = sum(dfor[ilen*ine+1:sumlen,3])

print(fz)
    
